MySQL logs can be set up via MySQL's my.cnf file. However, if the log file is not cleaned or recycled for a long time, it will cause the log file to become bigger and larger, thus affecting the performance of MySQL. And the use of the RPM package
The FLUSH command is often used for MySQL database backup. The following is a summary of the syntax. If the server uses the -- log-error option, FLUSHLOGS will cause the error day.
The FLUSH command is often used for MySQL database backup. The
The FLUSH command is often used for MySQL database backup. The following is a summary of the syntax.
FLUSH syntax
FLUSH [LOCAL | NO_WRITE_TO_BINLOG] flush_option [, flush_option]...
If you want to clear some internal caches used by MySQL, you should
Wait problems caused by--mysql flush-------------------------------2014/07/13PrefaceIn the actual production environment, a large number of SQL statements are sometimes found to be in waiting for table. State, sometimes it may seem confusing, this
Mud: mysql HELP command instructions, mud mysql
Do you need to remember many mysql commands when installing, managing, and using mysql. In addition, for beginners, there are not many commands that do not know how to apply them. For veterans, many
Mud: mysql HELP command instructions, mud mysql
This article was sponsored by Xiuyi linfeng and first launched in the dark world.
Do you need to remember many mysql commands when installing, managing, and using mysql. In addition, for beginners,
Rotten mud: mysql HELP command instructions
Do you need to remember many mysql commands when installing, managing, and using mysql. In addition, for beginners, there are not many commands that do not know how to apply them. For veterans, many
Flush syntax
Flush[Local | no_write_to_binlog]Flush_option[, Flush_option]...
If you want to clearMySQLYou should useFlushStatement. To executeFlush, You must haveReloadPermission.
Flush_option
Hosts
Used to clear the host cache table.
Today I carefully read the flush syntax and often use the flush command at work. Here I will summarize it. MySQL flush syntax (clear or reload internal cache) flush flush_option [, flush_option]. If you want to clear some MySQL instances using
I am used to installing MySQL in binary format. today I am eager to install an RPM Package for MySQL. I did not expect that I have encountered some problems. I will share with you the problems I encountered. first, I will download the installation
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.